USE [C211391_CodexOmega_DB]
GO
/****** Object:  View [dbo].[vwVideoLinker]    Script Date: 06/14/2009 08:59:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vwVideoLinker]
AS
SELECT     dbo.VideoLinker.VideoID, dbo.VideoLinker.VideoCategoryID, dbo.VideoLinker.VideoTypeID, dbo.VideoLinker.Title, dbo.VideoLinker.Description, dbo.VideoLinker.Code, 
                      dbo.VideoCategory.Definition AS VideoCategory, dbo.VideoType.Definition AS VideoType
FROM         dbo.VideoCategory INNER JOIN
                      dbo.VideoLinker ON dbo.VideoCategory.VideoCategoryID = dbo.VideoLinker.VideoCategoryID INNER JOIN
                      dbo.VideoType ON dbo.VideoLinker.VideoTypeID = dbo.VideoType.VideoTypeID
